<!DOCTYPE html>
<html lang="en" xmlns="http://www.w3.org/1999/html">
<head>
    <meta charset="UTF-8">
    <title>SQL</title>
</head>
<body>
<p></p>
<p></p>
<p></p>
<div id="main" style="width:100%; height:100%;">
<div class="first" id="left" style="float:left ; width:50%; height:100%;">
<h2 align="center">构建SQL语句查询数据库中数据</h2>
<div align="center">
<!--    <iframe src="static/table.html" width="40%" height="200"></iframe>-->
</div>
<div align="center">
    <form action="http://localhost:5000/SQL_SELECT" method="POST">
	<p>
		<p>SELECT like *</p>
         <p><input type = "text" name = "SELECT" /></p>
		<p>FROM like areawh</p>
         <p><input type = "text" name = "FROM" /></p>
		<p>WHERE</p>
         <p><input type = "text" name = "WHERE" /></p>
         <p><input type = "submit" value = "submit" /></p>
	</p>
 </form>
</div></div>

 <div class="second" id="right" style="float:left ; width:50%; height:100%;">
 <h2 align="center">查询POI数据</h2>
 <div align="center">
<!--    <iframe src="static/POI_table.html" width="40%" height="200"></iframe>-->
</div>
<div align="center">
    <form action="http://localhost:5000/POI_SELECT" method="POST">
	<p>
		<p>KeyWords like "医院"</p>
         <p><input type = "text" name = "KeyWords" /></p>
		<p>Province like "湖北省"(如果区域名唯一可以为空)</p>
         <p><input type = "text" name = "Province" /></p>
        <p>regions like "武汉市"</p>
         <p><input type = "text" name = "regions" /></p>
         <p><input type = "submit" value = "submit" /></p>
	</p>
 </form>
</div>
 </div>
 </div>
</body>
</html>